
Use [ConfigService]
go
--ConfigType:
alter table Config NOCHECK CONSTRAINT FK_Config_ConfigType
go
delete from ConfigType
go
SET IDENTITY_INSERT ConfigType ON
insert into ConfigType ([id],[description],modified,created,[name])values(1,'string','9-25-2008','9-25-2008','string')
insert into ConfigType ([id],[description],modified,created,[name])values(2,'int16','9-25-2008','9-25-2008','int16')
insert into ConfigType ([id],[description],modified,created,[name])values(3,'int32','9-25-2008','9-25-2008','int32')
insert into ConfigType ([id],[description],modified,created,[name])values(4,'int64','9-25-2008','9-25-2008','int64')
insert into ConfigType ([id],[description],modified,created,[name])values(5,'double','9-25-2008','9-25-2008','double')
insert into ConfigType ([id],[description],modified,created,[name])values(6,'decimal','9-25-2008','9-25-2008','decimal')
insert into ConfigType ([id],[description],modified,created,[name])values(7,'datetime','9-25-2008','9-25-2008','datetime')
SET IDENTITY_INSERT ConfigType OFF
go
alter table Config CHECK CONSTRAINT FK_Config_ConfigType
go 

--Mode:
SET IDENTITY_INSERT Mode ON
go
delete from Mode
go
insert into Mode([id],[Name],[Description],[Modified],[Created]) values(1,'DEV','development mode','9-25-2008','9-25-2008')
insert into Mode ([id],[Name],[Description],[Modified],[Created]) values(2,'TEST','test mode','9-25-2008','9-25-2008')
insert into Mode ([id],[Name],[Description],[Modified],[Created]) values(3,'LIVE','production mode','9-25-2008','9-25-2008')
SET IDENTITY_INSERT Mode OFF
go



--Application:
alter table Config NOCHECK CONSTRAINT FK_Config_Application
go
delete from [dbo].[Application]
go
SET IDENTITY_INSERT [Application] ON
insert into [Application] ([id],[description],[Modified],[Created],AppCode)values(1,'Test Application','9-25-2008','9-25-2008','TestApplication-2008')
insert into [Application] ([id],[description],[Modified],[Created],AppCode)values(2,'Test App Foo 1','9-25-2008','9-25-2008','APP-TEST-FOO1-2008')
insert into [Application] ([id],[description],[Modified],[Created],AppCode)values(3,'Test App Foo 2','9-25-2008','9-25-2008','APP-TEST-FOO2-2008')
insert into [Application] ([id],[description],[Modified],[Created],AppCode)values(4,'Test App Foo 3','9-25-2008','9-25-2008','APP-TEST-FOO3-2008')
SET IDENTITY_INSERT [Application] ON
go
alter table Config CHECK CONSTRAINT FK_Config_Application
go

--Config:
delete from config
insert into Config values('default app path','defaultimagepath','~/images','9-25-2008','9-25-2008',1,1,1)
insert into Config values('default app path','defaultimagepath','~/images','9-25-2008','9-25-2008',3,2,1)
insert into Config values('hello world','helloworldconfig','Hello World!','9-25-2008','9-25-2008',2,3,1)
insert into Config values('My Id','myid','1','9-25-2008','9-25-2008',3,4,2)
insert into Config values('Due Date','duedate','9-30-2008','9-25-2008','9-25-2008',1,1,7)
insert into Config values('test','testKey','testValue','9-25-2008','9-25-2008',1,1,1)
